/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80100
 Source Host           : localhost:3306
 Source Schema         : pay

 Target Server Type    : MySQL
 Target Server Version : 80100
 File Encoding         : 65001

 Date: 13/09/2023 19:50:00
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `pay_order`;
CREATE TABLE `pay_order`(
    `id`           bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '订单id',
    `subject`      varchar(256) DEFAULT NULL COMMENT '订单标题',
    `order_no`     varchar(50)  DEFAULT NULL COMMENT '商户订单编号',
    `total_amount` double       DEFAULT NULL COMMENT '订单金额',
    `status`       varchar(50)  DEFAULT NULL COMMENT '订单状态(WAIT_BUYER_PAY: 交易创建; TRADE_SUCCESS: 支付成功; TRADE_FINISHED: 交易完结; TRADE_CLOSED: 交易关闭)',
    `create_time`  datetime     DEFAULT NULL COMMENT '创建时间',
    `update_time`  datetime     DEFAULT NULL COMMENT '更新时间',
    `pay_type`     varchar(10)  DEFAULT NULL COMMENT '支付方式(支付宝; 微信; 银联)',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单表';

-- ----------------------------
-- Records of t_order
-- ----------------------------
BEGIN;
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (1, '董晓明', '899256809008558377', 776, 'CANCEL_SUCCESS', '2023-09-07 09:12:40', '2023-09-03 22:15:22', 'ZFB');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (2, '孙璐', '899256809008558378', 382, 'CANCEL_SUCCESS', '2023-09-06 01:15:26', '2023-09-08 11:38:36', 'WX');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (3, '许致远', '899256809008558379', 60, 'WAIT_BUYER_PAY', '2023-09-09 09:31:21', '2023-09-02 20:45:58', 'ZFB');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (4, '周璐', '899256809008558380', 531, 'CANCEL_SUCCESS', '2023-09-09 22:57:07', '2023-09-01 13:26:39', 'WX');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (5, '杜子韬', '899256809008558381', 408, 'TRADE_SUCCESS', '2023-09-08 23:24:56', '2023-09-07 09:33:38', 'YL');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (6, '潘睿', '899256809008558382', 867, 'TRADE_SUCCESS', '2023-09-05 23:21:54', '2023-09-08 03:18:37', 'ZFB');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (7, '程致远', '899256809008558383', 971, 'CANCEL_SUCCESS', '2023-09-01 15:48:25', '2023-09-03 04:42:40', 'ZFB');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (8, '姚璐', '899256809008558384', 526, 'TRADE_SUCCESS', '2023-09-05 15:01:18', '2023-09-07 06:01:35', 'WX');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (9, '龙震南', '899256809008558385', 91, 'CANCEL_SUCCESS', '2023-09-08 00:51:03', '2023-09-08 03:27:53', 'ZFB');
INSERT INTO `pay_order` (`id`, `subject`, `order_no`, `total_amount`, `status`, `create_time`, `update_time`, `pay_type`) VALUES (10, '朱杰宏', '899256809008558386', 663, 'CANCEL_SUCCESS', '2023-09-05 19:00:22', '2023-09-02 04:57:57', 'YL');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
